Entity immovable property

Details of entity immovable property

Name

immovable property

Code

immovable_property

Parent

Logical Data Model 'AnaCredit GLO per bank LDM'

Comment

Immovable property is protection received that does have a fixed location according to its type.

Parent Entity

protection received

rowcount reporting indicator

entity type with reported rowcount


List of attributes of the entity immovable property

Name

Code

Comment

Data Type

Domain

Mandatory

Primary Identifier

Foreign Identifier

reporting agent identifier

reporting_agent_identifier

Reporting agent identifier is a number, assigned by De Nederlandsche Bank, that uniquely identifies the reporting agent.

Variable characters (50)

riad counterparty domain

X

X

 

protection identifier

prtctn_id

An identifier applied by the reporting agent to uniquely identify each protection used to secure the instrument. Each protection must have one protection identifier. This value will not change over time and cannot be used as the protection identifier for any other protection.

Variable characters (60)

identifier domain

X

X

 

reporting reference date

reporting_reference_date

reporting reference date is a date that indicates the date the entity type delivery pertains to.

Defined as yyyy-mm-dd.

Date

reporting reference date

X

X

 

real estate collateral location country

real_estate_collateral_location_country

Real estate collateral location country is the ISO 3166 country code identifying the country in which immovable property is situated.

Characters (2)

ISO 3166 Country

X

 

X

real estate collateral location postal code

real_estate_collateral_location_postal_code

Real estate collateral location postal code is a code identifying the postal code area in which the immovable property is situated.

Variable multibyte (20)

postal code with exclusions

 

 

 

immovable property location indicator

immovable_property_location_indicator

Immovable property location indicator distinguishes between those immovable properties that are located in a reporting member state and those that are located outside of a reporting member state.

Variable characters (50)

immovable property location indicator

X

 

 


List of child entities of the entity immovable property

Child Entity

Inheritance

collateral located in a reporting member state

immovable property location indicator

collateral not located in a reporting member state

immovable property location indicator


List of relationships of the entity immovable property

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

is location of

country_is_location_of_immovable_property

X

immovable property

country

 

0,n

1,1


List of child inheritances of the entity immovable property

Name

Code

Mutually Exclusive

Inherit All

Generate Parent

Generate Children

immovable property location indicator

immovable_property_location_indicator

X

 

X

X


List of identifiers of the entity immovable property

Name

Code

Parent

Primary Identifier

immovable property PK

immovable_property_pk

Entity 'immovable property'

X